import pandas as pd
data = pd.read_excel('F:\\python\\第7章\\员工档案表3.xlsx', sheet_name=0)
a = data.groupby(by=['部门', '性别'])
for name, group in a:
    print(name)
    print(group)
